﻿CREATE TABLE [dbo].[Store_Product] (
    [Id]             INT           IDENTITY (1, 1) NOT NULL,
    [ArtNo]          INT           NOT NULL,
    [Discount]       INT           NOT NULL,
    [ItemsSold]      INT           NOT NULL,
    [CreationDate]   DATETIME      CONSTRAINT [DF_Store_Product_CreationDate] DEFAULT (getdate()) NOT NULL,
    [IsFreeShiping]  BIT           NOT NULL,
    [IsNew]          BIT           NOT NULL,
    [IsOnSale]       BIT           NOT NULL,
    [IsDownloadable] BIT           NOT NULL,
    [IsEnabled]      BIT           NOT NULL,
    [FriendlyUrl]    NVARCHAR (64) NOT NULL,
    [SortOrder]      INT           NOT NULL,
    CONSTRAINT [PK_Store_Product] PRIMARY KEY CLUSTERED ([Id] ASC)
);

